package backstage.app.mapper;

 

import java.util.List;


import org.springframework.stereotype.Repository;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

import backstage.app.entity.AllStudent;
import backstage.app.entity.NoStudent;
import backstage.app.entity.StudentEcharts;
 
 
@Repository
public interface NoStudentMapper extends BaseMapper<NoStudent>{
     
    int deleteByPrimaryKey(Integer sid);

    /***
     * 统计总数以及年，月，周，日
     * @return
     */
    AllStudent selectAllStudent();
    
    /**统计最新30条数据*/
    List<StudentEcharts> selectEchartsList();
    
    int insertSelective(NoStudent student);

    int selectByPrimaryKeyCountType(Integer studentType);

    NoStudent selectByPrimaryKey(Integer sid);
 
    List<NoStudent> selectlimitAndWhere(String name,Integer studentType,Integer page,Integer limit);
    
    List<NoStudent> selectlimitAndWhereNostudentType(String name,Integer page,Integer limit);
    
    List<NoStudent> selectlimitAndWhereNotType(Integer page,Integer limit);
    
    List<NoStudent>selectlimitAndWhereNotTypeHaveName(String name,Integer page,Integer limit);
    
    int updateByPrimaryKey(NoStudent student);
}